package com.jn.one.mapper;

import com.jn.one.model.Health;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface HealthMapper {
    @Insert("insert into HealthSurvey values(#{name},#{gender},#{age},#{phone},#{cars},#{company},#{height}," +
            "#{weight},#{yaowei},#{mybmi},#{fill},#{mill},#{hproblem},#{tydlpl},#{ysxg},#{xyqk},#{yjpl},#{kpjz},#{jkgl})")
    public int insertall(@Param("name")String name,@Param("gender")String gender,@Param("age")int age,@Param("phone")int phone,@Param("cars")String cars,@Param("company")String company,@Param("height")int height,
                         @Param("weight")int weight,@Param("yaowei")int yaowei,@Param("mybmi")float mybmi,@Param("fill")String fill,@Param("mill")String mill,@Param("hproblem")String hproblem,@Param("tydlpl")String tydlpl,
                         @Param("ysxg")String ysxg,@Param("xyqk")String xyqk,@Param("yjpl")String yjpl,@Param("kpjz")String kpjz,@Param("jkgl")String jkgl);

    @Insert("insert into HealthSurvey values(#{name},#{age},#{gender},#{phone},#{cars},#{company},#{height},#{weight},#{yaowei},#{mybmi},#{fill},#{mill},#{hproblem},#{tydlpl},#{ysxg},#{xyqk},#{yjpl},#{kpjz},#{jkgl})")
    public int insertall2(Health health);
}
